Parts Database Data Record Structure
This is the structure of a database record in the main OpenUtilities Substation parts database.
| Field Name | Data Type | Field Size | Description |
|---|---|---|---|
| Part_Number | Text | 30 | Part number |
| Category | Text | 50 | Description of part |
| Manufacturer | Text | 30 | Manufacturer |
| URL | Text | 255 | Hyperlink for part number |
| Catalog_Number | Text | 30 | Catalog part number |
| Supplier | Text | 50 | Supplier of part |
| Part_Type | Text | 3 | Part type group |
| Additional_Part | Text | 255 | Additional part numbers |
| Percent_Spare | Floating Point | Percent of spare parts | |
| Quantity_Per_Unit | Floating Point | Quantity in part number | |
| Use_Unit | Text | 12 | Unit in which part is used |
| Order_Unit | Text | 50 | Unit in which part is ordered |
| Buying_Price | Floating Pint | Supplier's price | |
| Selling_Price | Floating Point | Price charged to customer | |
| Discount | Floating Point | Percent discount | |
| Detailed_Description - Detailed_Description5 | Text | 128 | Extended descriptions of part |
| X | Floating Point | X Dimension of device | |
| Y | Floating Point | Y Dimension of device | |
| Z | Floating Point | Z Dimension of device | |
| Diameter | Floating Point | Diameter of part | |
| Location | Text | 128 | Location of part |
| Weight | Floating Point | Weight of part | |
| Power_Consumption | Floating Point | Power consumption | |
| Assembly_Time | Int16 | 32767 max. | Assembly time |
| Wiring_Time | Int16 | 32767 max. | Wiring time |
| Hour_Cost | Floating Point | Hourly labor cost | |
| Date_Created | Data | 10 | Date part record was created |
| Date_Modified | Date | 10 | Date part record was edited |
| Device_Family | Text | 50 | Device family of part |
| Attribute_Text | Text | 255 | Symbol attribute and value |
| Single_Wire_Connection | Text | 128 | Conn. points for single wire |
| Schematic_Symbol | Text | 128 | Symbol for schematics |
| Layout_Symbol | Text | 128 | Symbol for panel layouts |
| Wire_Diagram_Symbol | Text | 128 | Symbol for wiring diagram |
| Hydraulic_Symbol | Text | 128 | Symbol for hydraulic dwgs |
| Pneumatic_Symbol | Text | 128 | Symbol for pneumatic dwgs |
| Single_Line_Symbol | Text | 128 | Symbol for single line dwgs |
| Graphic_Plan_Symbol | Text | 128 | Symbol for terminal plans. |